問1
CREATE TABLE book_table(book_id INT, book_name VARCHAR(50), author_name VARCHAR(50), price INT, sales_flag INT);

問2
INSERT INTO book_table VALUES (10001, 'TwoPeace', '三田英一郎', 420, 1);
INSERT INTO book_table VALUES (10002, '名探偵金田二', '青山ふみや', 460, 1);
INSERT INTO book_table VALUES (20001, '坊ちゃま', '冬目漱石', 460, 1);
INSERT INTO book_table VALUES (30001, '西方見聞録', '不明', 1000, 1);
INSERT INTO book_table VALUES (40010, '吾輩は犬である', '冬目漱石', 420, 1);

問3
SELECT book_name, author_name FROM book_table;

問4
UPDATE book_table SET author_name = 'マール=コ-=ポロ' WHERE book_id = 30001;
UPDATE book_table SET sales_flag = 0 WHERE book_id = 30001;

問5
SELECT * FROM book_table WHERE sales_flag = 1;

問6
SELECT * FROM book_table WHERE author_name = '冬目漱石' AND price = 420;

問7
DELETE FROM book_table WHERE book_id = 20001;